Hospital Analytics in SQL

Overview

This project is a comprehensive SQL-based data analysis conducted for Massachusetts General Hospital, covering a 12-year period from 2011 to 2022. The objective was to derive meaningful insights from hospital patient records to support annual performance evaluation, operational planning, and strategic improvements in healthcare delivery. A total of 75,592 synthetic records were analyzed from three core relational tables: encounters, procedures, and payers. SQL queries were used exclusively to explore trends in patient visits, identify inefficiencies, and uncover cost and insurance-related gaps. The analysis was categorized into three pillars: Encounter Overview, Cost & Coverage Insights, and Patient Behavior Analysis.

Key outcomes from the project include identifying yearly patterns in hospital visits, classifying encounter types, calculating visit durations, and flagging high-cost procedures. Additionally, the project highlights areas with limited or no insurance coverage and reveals readmission patterns, including the frequency of 30-day readmissions.

The insights derived can help hospital administrators reduce operational costs, improve patient care quality, enhance insurance verification processes, and develop strategies to minimize unnecessary readmissions. This project demonstrates the power of SQL in healthcare analytics and lays a foundation for data-driven decision making in clinical operations.